USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_UpdatePlace]    Script Date: 05/29/2011 19:51:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_UpdatePlace] 
  @short  nvarchar(20) = '',
  @name  nvarchar(100) = '',
  @placetype_id bigint,
  @isActive bit = 1,
  @country_id bigint=null,
  @id bigint
as
	UPDATE Places SET short = @short, [name] = @name, placetype_id=@placetype_id, isActive = @isActive, country_id = @country_id
	WHERE id=@id

GO


